Page 61 - Data_Science_Part_A C12

Action Command/Menu Option
Making the text Bold, Italic or Underline
or use keyboard shortcuts as follows:
Bold – Ctrl + B
Italic – Ctrl + I
Underline – Ctrl +U

Changing the font colour or background
colour of the text

Task 21 st Century #Technology Literacy
Skills

Create the following spreadsheet:

Do the following:
1. Add 5 more rows as per the data shown above.
2. Calculate the following:
• Sum of salaries
• Average of salaries
• Find the name of the employee having the minimum salary. Which department does this employee
belong to?
3. Format the data giving separate colours and fonts to the headings and data.

ICT Skills-III 59